﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_USER_FIRST_ACCESS_UP')
	BEGIN
		DROP  Procedure  dbo.PRC_USER_FIRST_ACCESS_UP
	END

GO

CREATE PROCEDURE [dbo].[PRC_USER_FIRST_ACCESS_UP] 
(
    @TU_ID Integer,
    @TU_FIRST_ACCESS Integer 
)
AS
    UPDATE TB_USER
    SET TU_FIRST_ACCESS = @TU_FIRST_ACCESS
    WHERE TU_ID = @TU_ID


GO

GRANT EXEC ON dbo.PRC_USER_FIRST_ACCESS_UP TO PUBLIC

GO

